﻿SELECT ROW_NUMBER() OVER(ORDER BY tu.UserID ASC) AS rownumber,tu.UserID
  FROM TheUser tu ORDER BY tu.UserID ASC